{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('satp_raw_data.csv') ## Raw file taken from SATP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['Date'] = pd.to_datetime(data['Date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Place</th>\n",
       "      <th>No of Incidents</th>\n",
       "      <th>Civilians - Killed</th>\n",
       "      <th>Civilians - Injured</th>\n",
       "      <th>SFs - Killed</th>\n",
       "      <th>SFs - Injured</th>\n",
       "      <th>Militants - Killed</th>\n",
       "      <th>Militants - Injured</th>\n",
       "      <th>Total - Killed</th>\n",
       "      <th>Total - Injured</th>\n",
       "      <th>No of Arrests</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-01-03</td>\n",
       "      <td>Pulwama/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-01-08</td>\n",
       "      <td>Tral town Bus Stand/Pulwama/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-01-12</td>\n",
       "      <td>Katpora/Kulgam/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-01-13</td>\n",
       "      <td>Sugan/Shopian/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-21</td>\n",
       "      <td>Rajpora Chowk, Murran Chowk and Kakapora areas...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>2010-11-16</td>\n",
       "      <td>Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>2010-11-19</td>\n",
       "      <td>Jammu &amp; Kashmir</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>2010-11-23</td>\n",
       "      <td>Anantnag/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>2009-12-11</td>\n",
       "      <td>Srinagar/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>2009-12-12</td>\n",
       "      <td>Srinagar/Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>653 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date                                              Place  \\\n",
       "0   2019-01-03                            Pulwama/Jammu & Kashmir   \n",
       "1   2019-01-08        Tral town Bus Stand/Pulwama/Jammu & Kashmir   \n",
       "2   2019-01-12                     Katpora/Kulgam/Jammu & Kashmir   \n",
       "3   2019-01-13                      Sugan/Shopian/Jammu & Kashmir   \n",
       "4   2019-01-21  Rajpora Chowk, Murran Chowk and Kakapora areas...   \n",
       "..         ...                                                ...   \n",
       "648 2010-11-16                                    Jammu & Kashmir   \n",
       "649 2010-11-19                                    Jammu & Kashmir   \n",
       "650 2010-11-23                           Anantnag/Jammu & Kashmir   \n",
       "651 2009-12-11                           Srinagar/Jammu & Kashmir   \n",
       "652 2009-12-12                           Srinagar/Jammu & Kashmir   \n",
       "\n",
       "     No of Incidents  Civilians - Killed  Civilians - Injured  SFs - Killed  \\\n",
       "0                1.0                   0                   12             0   \n",
       "1                1.0                   0                    1             0   \n",
       "2                1.0                   0                    0             0   \n",
       "3                1.0                   0                   12             0   \n",
       "4                3.0                   0                    0             0   \n",
       "..               ...                 ...                  ...           ...   \n",
       "648              1.0                   0                    5             0   \n",
       "649              3.0                   0                    0             0   \n",
       "650              1.0                   0                    3             0   \n",
       "651              1.0                   0                   41             0   \n",
       "652              1.0                   0                    9             0   \n",
       "\n",
       "     SFs - Injured  Militants - Killed  Militants - Injured  Total - Killed  \\\n",
       "0                0                   0                    0               0   \n",
       "1                0                   0                    0               0   \n",
       "2                0                   0                    0               0   \n",
       "3                0                   0                    0               0   \n",
       "4                0                   0                    0               0   \n",
       "..             ...                 ...                  ...             ...   \n",
       "648              0                   0                    0               0   \n",
       "649              1                   0                    0               0   \n",
       "650              0                   0                    0               0   \n",
       "651             59                   0                    0               0   \n",
       "652              1                   0                    0               0   \n",
       "\n",
       "     Total - Injured  No of Arrests  \n",
       "0                 12              0  \n",
       "1                  1              0  \n",
       "2                  0              0  \n",
       "3                 12              0  \n",
       "4                  0              0  \n",
       "..               ...            ...  \n",
       "648                5              0  \n",
       "649                1              0  \n",
       "650                3              0  \n",
       "651              100              0  \n",
       "652               10              0  \n",
       "\n",
       "[653 rows x 12 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['Place']= data[\"Place\"].str.replace(\"/Jammu & Kashmir\", \"\")\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Anantnag.*$)', 'Anantnag')\n",
    "## Replacing South Kashmir with Anantnag\n",
    "data['Place'] = data.Place.str.replace('South Kashmir', 'Anantnag')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Bandipore.*$)', 'Bandipur')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Baramulla.*$)', 'Baramulla')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Budgam.*$)', 'Badgam')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Doda.*$)', 'Doda')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Ganderbal.*$)', 'Ganderbal')\n",
    "data['Place'] = data.Place.str.replace('Jammu', 'Jammu')\n",
    "data['Place'] = data.Place.str.replace('Mendhar town/Jammu', 'Jammu')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Kargil.*$)', 'Kargil')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Kathua.*$)', 'Kathua')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Kishtwar.*$)', 'Kishtwar')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Kulgam.*$)', 'Kulgam')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Kupwara.*$)', 'Kupwara')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Leh.*$)', 'Leh')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Poonch.*$)', 'Poonch')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Pulwama.*$)', 'Pulwama')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Rajouri.*$)', 'Rajauri')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Ramban.*$)', 'Ramban')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Samba.*$)', 'Samba')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Shopian.*$)', 'Shupiyan')\n",
    "data['Place'] = data.Place.str.replace(r'(^.*Srinagar.*$)', 'Srinagar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Place</th>\n",
       "      <th>No of Incidents</th>\n",
       "      <th>Civilians - Killed</th>\n",
       "      <th>Civilians - Injured</th>\n",
       "      <th>SFs - Killed</th>\n",
       "      <th>SFs - Injured</th>\n",
       "      <th>Militants - Killed</th>\n",
       "      <th>Militants - Injured</th>\n",
       "      <th>Total - Killed</th>\n",
       "      <th>Total - Injured</th>\n",
       "      <th>No of Arrests</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-01-03</td>\n",
       "      <td>Pulwama</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-01-08</td>\n",
       "      <td>Pulwama</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-01-12</td>\n",
       "      <td>Kulgam</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-01-13</td>\n",
       "      <td>Shupiyan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-21</td>\n",
       "      <td>Pulwama</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>2010-11-16</td>\n",
       "      <td>Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>2010-11-19</td>\n",
       "      <td>Jammu &amp; Kashmir</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>2010-11-23</td>\n",
       "      <td>Anantnag</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>2009-12-11</td>\n",
       "      <td>Srinagar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>2009-12-12</td>\n",
       "      <td>Srinagar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>653 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date            Place  No of Incidents  Civilians - Killed  \\\n",
       "0   2019-01-03          Pulwama              1.0                   0   \n",
       "1   2019-01-08          Pulwama              1.0                   0   \n",
       "2   2019-01-12           Kulgam              1.0                   0   \n",
       "3   2019-01-13         Shupiyan              1.0                   0   \n",
       "4   2019-01-21          Pulwama              3.0                   0   \n",
       "..         ...              ...              ...                 ...   \n",
       "648 2010-11-16  Jammu & Kashmir              1.0                   0   \n",
       "649 2010-11-19  Jammu & Kashmir              3.0                   0   \n",
       "650 2010-11-23         Anantnag              1.0                   0   \n",
       "651 2009-12-11         Srinagar              1.0                   0   \n",
       "652 2009-12-12         Srinagar              1.0                   0   \n",
       "\n",
       "     Civilians - Injured  SFs - Killed  SFs - Injured  Militants - Killed  \\\n",
       "0                     12             0              0                   0   \n",
       "1                      1             0              0                   0   \n",
       "2                      0             0              0                   0   \n",
       "3                     12             0              0                   0   \n",
       "4                      0             0              0                   0   \n",
       "..                   ...           ...            ...                 ...   \n",
       "648                    5             0              0                   0   \n",
       "649                    0             0              1                   0   \n",
       "650                    3             0              0                   0   \n",
       "651                   41             0             59                   0   \n",
       "652                    9             0              1                   0   \n",
       "\n",
       "     Militants - Injured  Total - Killed  Total - Injured  No of Arrests  \n",
       "0                      0               0               12              0  \n",
       "1                      0               0                1              0  \n",
       "2                      0               0                0              0  \n",
       "3                      0               0               12              0  \n",
       "4                      0               0                0              0  \n",
       "..                   ...             ...              ...            ...  \n",
       "648                    0               0                5              0  \n",
       "649                    0               0                1              0  \n",
       "650                    0               0                3              0  \n",
       "651                    0               0              100              0  \n",
       "652                    0               0               10              0  \n",
       "\n",
       "[653 rows x 12 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Anantnag',\n",
       " 'Badgam',\n",
       " 'Bandipur',\n",
       " 'Baramulla',\n",
       " 'Doda',\n",
       " 'Ganderbal',\n",
       " 'Jammu',\n",
       " 'Jammu & Kashmir',\n",
       " 'Kishtwar',\n",
       " 'Kulgam',\n",
       " 'Kupwara',\n",
       " 'Poonch',\n",
       " 'Pulwama',\n",
       " 'Rajauri',\n",
       " 'Ramban',\n",
       " 'Shupiyan',\n",
       " 'Srinagar',\n",
       " 'nan']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list1 = data['Place'].unique()\n",
    "list1 = list1.astype('str')\n",
    "sorted(list1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We have following missing districts: kargil, kathua, leh, samba, udhampur"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(r'satp_cleaned_data.csv') ## Cleaned district names data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Place</th>\n",
       "      <th>No of Incidents</th>\n",
       "      <th>Civilians - Killed</th>\n",
       "      <th>Civilians - Injured</th>\n",
       "      <th>SFs - Killed</th>\n",
       "      <th>SFs - Injured</th>\n",
       "      <th>Militants - Killed</th>\n",
       "      <th>Militants - Injured</th>\n",
       "      <th>Total - Killed</th>\n",
       "      <th>Total - Injured</th>\n",
       "      <th>No of Arrests</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-01-03</td>\n",
       "      <td>Pulwama</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-01-08</td>\n",
       "      <td>Pulwama</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-01-12</td>\n",
       "      <td>Kulgam</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-01-13</td>\n",
       "      <td>Shupiyan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-21</td>\n",
       "      <td>Pulwama</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>2010-11-16</td>\n",
       "      <td>Jammu &amp; Kashmir</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>2010-11-19</td>\n",
       "      <td>Jammu &amp; Kashmir</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>2010-11-23</td>\n",
       "      <td>Anantnag</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>2009-12-11</td>\n",
       "      <td>Srinagar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>2009-12-12</td>\n",
       "      <td>Srinagar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>653 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date            Place  No of Incidents  Civilians - Killed  \\\n",
       "0   2019-01-03          Pulwama              1.0                   0   \n",
       "1   2019-01-08          Pulwama              1.0                   0   \n",
       "2   2019-01-12           Kulgam              1.0                   0   \n",
       "3   2019-01-13         Shupiyan              1.0                   0   \n",
       "4   2019-01-21          Pulwama              3.0                   0   \n",
       "..         ...              ...              ...                 ...   \n",
       "648 2010-11-16  Jammu & Kashmir              1.0                   0   \n",
       "649 2010-11-19  Jammu & Kashmir              3.0                   0   \n",
       "650 2010-11-23         Anantnag              1.0                   0   \n",
       "651 2009-12-11         Srinagar              1.0                   0   \n",
       "652 2009-12-12         Srinagar              1.0                   0   \n",
       "\n",
       "     Civilians - Injured  SFs - Killed  SFs - Injured  Militants - Killed  \\\n",
       "0                     12             0              0                   0   \n",
       "1                      1             0              0                   0   \n",
       "2                      0             0              0                   0   \n",
       "3                     12             0              0                   0   \n",
       "4                      0             0              0                   0   \n",
       "..                   ...           ...            ...                 ...   \n",
       "648                    5             0              0                   0   \n",
       "649                    0             0              1                   0   \n",
       "650                    3             0              0                   0   \n",
       "651                   41             0             59                   0   \n",
       "652                    9             0              1                   0   \n",
       "\n",
       "     Militants - Injured  Total - Killed  Total - Injured  No of Arrests  \n",
       "0                      0               0               12              0  \n",
       "1                      0               0                1              0  \n",
       "2                      0               0                0              0  \n",
       "3                      0               0               12              0  \n",
       "4                      0               0                0              0  \n",
       "..                   ...             ...              ...            ...  \n",
       "648                    0               0                5              0  \n",
       "649                    0               0                1              0  \n",
       "650                    0               0                3              0  \n",
       "651                    0               0              100              0  \n",
       "652                    0               0               10              0  \n",
       "\n",
       "[653 rows x 12 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
